package com.ecoolex.chinadutyfree.retailer.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class CouponExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public CouponExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public CouponExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public CouponExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        CouponExample example = new CouponExample();
        return example.createCriteria();
    }

    public CouponExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public CouponExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public CouponExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public CouponExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public CouponExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andCouponIdIsNull() {
            addCriterion("coupon.CouponId is null");
            return (Criteria) this;
        }

        public Criteria andCouponIdIsNotNull() {
            addCriterion("coupon.CouponId is not null");
            return (Criteria) this;
        }

        public Criteria andCouponIdEqualTo(Integer value) {
            addCriterion("coupon.CouponId =", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponIdNotEqualTo(Integer value) {
            addCriterion("coupon.CouponId <>", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdNotEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponIdGreaterThan(Integer value) {
            addCriterion("coupon.CouponId >", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdGreaterThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("coupon.CouponId >=", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdGreaterThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponIdLessThan(Integer value) {
            addCriterion("coupon.CouponId <", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdLessThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponIdLessThanOrEqualTo(Integer value) {
            addCriterion("coupon.CouponId <=", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdLessThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponIdIn(List<Integer> values) {
            addCriterion("coupon.CouponId in", values, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdNotIn(List<Integer> values) {
            addCriterion("coupon.CouponId not in", values, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdBetween(Integer value1, Integer value2) {
            addCriterion("coupon.CouponId between", value1, value2, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdNotBetween(Integer value1, Integer value2) {
            addCriterion("coupon.CouponId not between", value1, value2, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponClassIdIsNull() {
            addCriterion("coupon.CouponClassId is null");
            return (Criteria) this;
        }

        public Criteria andCouponClassIdIsNotNull() {
            addCriterion("coupon.CouponClassId is not null");
            return (Criteria) this;
        }

        public Criteria andCouponClassIdEqualTo(Integer value) {
            addCriterion("coupon.CouponClassId =", value, "couponClassId");
            return (Criteria) this;
        }

        public Criteria andCouponClassIdEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponClassId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponClassIdNotEqualTo(Integer value) {
            addCriterion("coupon.CouponClassId <>", value, "couponClassId");
            return (Criteria) this;
        }

        public Criteria andCouponClassIdNotEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponClassId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponClassIdGreaterThan(Integer value) {
            addCriterion("coupon.CouponClassId >", value, "couponClassId");
            return (Criteria) this;
        }

        public Criteria andCouponClassIdGreaterThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponClassId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponClassIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("coupon.CouponClassId >=", value, "couponClassId");
            return (Criteria) this;
        }

        public Criteria andCouponClassIdGreaterThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponClassId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponClassIdLessThan(Integer value) {
            addCriterion("coupon.CouponClassId <", value, "couponClassId");
            return (Criteria) this;
        }

        public Criteria andCouponClassIdLessThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponClassId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponClassIdLessThanOrEqualTo(Integer value) {
            addCriterion("coupon.CouponClassId <=", value, "couponClassId");
            return (Criteria) this;
        }

        public Criteria andCouponClassIdLessThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponClassId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponClassIdIn(List<Integer> values) {
            addCriterion("coupon.CouponClassId in", values, "couponClassId");
            return (Criteria) this;
        }

        public Criteria andCouponClassIdNotIn(List<Integer> values) {
            addCriterion("coupon.CouponClassId not in", values, "couponClassId");
            return (Criteria) this;
        }

        public Criteria andCouponClassIdBetween(Integer value1, Integer value2) {
            addCriterion("coupon.CouponClassId between", value1, value2, "couponClassId");
            return (Criteria) this;
        }

        public Criteria andCouponClassIdNotBetween(Integer value1, Integer value2) {
            addCriterion("coupon.CouponClassId not between", value1, value2, "couponClassId");
            return (Criteria) this;
        }

        public Criteria andCouponCodeIsNull() {
            addCriterion("coupon.CouponCode is null");
            return (Criteria) this;
        }

        public Criteria andCouponCodeIsNotNull() {
            addCriterion("coupon.CouponCode is not null");
            return (Criteria) this;
        }

        public Criteria andCouponCodeEqualTo(String value) {
            addCriterion("coupon.CouponCode =", value, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponCode = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponCodeNotEqualTo(String value) {
            addCriterion("coupon.CouponCode <>", value, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeNotEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponCode <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponCodeGreaterThan(String value) {
            addCriterion("coupon.CouponCode >", value, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeGreaterThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponCode > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponCodeGreaterThanOrEqualTo(String value) {
            addCriterion("coupon.CouponCode >=", value, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeGreaterThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponCode >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponCodeLessThan(String value) {
            addCriterion("coupon.CouponCode <", value, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeLessThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponCode < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponCodeLessThanOrEqualTo(String value) {
            addCriterion("coupon.CouponCode <=", value, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeLessThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CouponCode <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCouponCodeLike(String value) {
            addCriterion("coupon.CouponCode like", value, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeNotLike(String value) {
            addCriterion("coupon.CouponCode not like", value, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeIn(List<String> values) {
            addCriterion("coupon.CouponCode in", values, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeNotIn(List<String> values) {
            addCriterion("coupon.CouponCode not in", values, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeBetween(String value1, String value2) {
            addCriterion("coupon.CouponCode between", value1, value2, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeNotBetween(String value1, String value2) {
            addCriterion("coupon.CouponCode not between", value1, value2, "couponCode");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("coupon.UserId is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("coupon.UserId is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(Integer value) {
            addCriterion("coupon.UserId =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UserId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(Integer value) {
            addCriterion("coupon.UserId <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UserId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(Integer value) {
            addCriterion("coupon.UserId >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UserId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("coupon.UserId >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UserId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(Integer value) {
            addCriterion("coupon.UserId <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UserId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("coupon.UserId <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UserId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<Integer> values) {
            addCriterion("coupon.UserId in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<Integer> values) {
            addCriterion("coupon.UserId not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(Integer value1, Integer value2) {
            addCriterion("coupon.UserId between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("coupon.UserId not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeIsNull() {
            addCriterion("coupon.StartEffectiveTime is null");
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeIsNotNull() {
            addCriterion("coupon.StartEffectiveTime is not null");
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeEqualTo(Date value) {
            addCriterion("coupon.StartEffectiveTime =", value, "startEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.StartEffectiveTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeNotEqualTo(Date value) {
            addCriterion("coupon.StartEffectiveTime <>", value, "startEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeNotEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.StartEffectiveTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeGreaterThan(Date value) {
            addCriterion("coupon.StartEffectiveTime >", value, "startEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeGreaterThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.StartEffectiveTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("coupon.StartEffectiveTime >=", value, "startEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeGreaterThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.StartEffectiveTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeLessThan(Date value) {
            addCriterion("coupon.StartEffectiveTime <", value, "startEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeLessThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.StartEffectiveTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeLessThanOrEqualTo(Date value) {
            addCriterion("coupon.StartEffectiveTime <=", value, "startEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeLessThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.StartEffectiveTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeIn(List<Date> values) {
            addCriterion("coupon.StartEffectiveTime in", values, "startEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeNotIn(List<Date> values) {
            addCriterion("coupon.StartEffectiveTime not in", values, "startEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeBetween(Date value1, Date value2) {
            addCriterion("coupon.StartEffectiveTime between", value1, value2, "startEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andStartEffectiveTimeNotBetween(Date value1, Date value2) {
            addCriterion("coupon.StartEffectiveTime not between", value1, value2, "startEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeIsNull() {
            addCriterion("coupon.EndEffectiveTime is null");
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeIsNotNull() {
            addCriterion("coupon.EndEffectiveTime is not null");
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeEqualTo(Date value) {
            addCriterion("coupon.EndEffectiveTime =", value, "endEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.EndEffectiveTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeNotEqualTo(Date value) {
            addCriterion("coupon.EndEffectiveTime <>", value, "endEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeNotEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.EndEffectiveTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeGreaterThan(Date value) {
            addCriterion("coupon.EndEffectiveTime >", value, "endEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeGreaterThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.EndEffectiveTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("coupon.EndEffectiveTime >=", value, "endEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeGreaterThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.EndEffectiveTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeLessThan(Date value) {
            addCriterion("coupon.EndEffectiveTime <", value, "endEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeLessThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.EndEffectiveTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeLessThanOrEqualTo(Date value) {
            addCriterion("coupon.EndEffectiveTime <=", value, "endEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeLessThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.EndEffectiveTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeIn(List<Date> values) {
            addCriterion("coupon.EndEffectiveTime in", values, "endEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeNotIn(List<Date> values) {
            addCriterion("coupon.EndEffectiveTime not in", values, "endEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeBetween(Date value1, Date value2) {
            addCriterion("coupon.EndEffectiveTime between", value1, value2, "endEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andEndEffectiveTimeNotBetween(Date value1, Date value2) {
            addCriterion("coupon.EndEffectiveTime not between", value1, value2, "endEffectiveTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeIsNull() {
            addCriterion("coupon.UseTime is null");
            return (Criteria) this;
        }

        public Criteria andUseTimeIsNotNull() {
            addCriterion("coupon.UseTime is not null");
            return (Criteria) this;
        }

        public Criteria andUseTimeEqualTo(Date value) {
            addCriterion("coupon.UseTime =", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UseTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUseTimeNotEqualTo(Date value) {
            addCriterion("coupon.UseTime <>", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeNotEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UseTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUseTimeGreaterThan(Date value) {
            addCriterion("coupon.UseTime >", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeGreaterThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UseTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUseTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("coupon.UseTime >=", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeGreaterThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UseTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUseTimeLessThan(Date value) {
            addCriterion("coupon.UseTime <", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeLessThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UseTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUseTimeLessThanOrEqualTo(Date value) {
            addCriterion("coupon.UseTime <=", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeLessThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UseTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUseTimeIn(List<Date> values) {
            addCriterion("coupon.UseTime in", values, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeNotIn(List<Date> values) {
            addCriterion("coupon.UseTime not in", values, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeBetween(Date value1, Date value2) {
            addCriterion("coupon.UseTime between", value1, value2, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeNotBetween(Date value1, Date value2) {
            addCriterion("coupon.UseTime not between", value1, value2, "useTime");
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneIsNull() {
            addCriterion("coupon.ReceiverPhone is null");
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneIsNotNull() {
            addCriterion("coupon.ReceiverPhone is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneEqualTo(String value) {
            addCriterion("coupon.ReceiverPhone =", value, "receiverPhone");
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.ReceiverPhone = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneNotEqualTo(String value) {
            addCriterion("coupon.ReceiverPhone <>", value, "receiverPhone");
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneNotEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.ReceiverPhone <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneGreaterThan(String value) {
            addCriterion("coupon.ReceiverPhone >", value, "receiverPhone");
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneGreaterThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.ReceiverPhone > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("coupon.ReceiverPhone >=", value, "receiverPhone");
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneGreaterThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.ReceiverPhone >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneLessThan(String value) {
            addCriterion("coupon.ReceiverPhone <", value, "receiverPhone");
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneLessThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.ReceiverPhone < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneLessThanOrEqualTo(String value) {
            addCriterion("coupon.ReceiverPhone <=", value, "receiverPhone");
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneLessThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.ReceiverPhone <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneLike(String value) {
            addCriterion("coupon.ReceiverPhone like", value, "receiverPhone");
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneNotLike(String value) {
            addCriterion("coupon.ReceiverPhone not like", value, "receiverPhone");
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneIn(List<String> values) {
            addCriterion("coupon.ReceiverPhone in", values, "receiverPhone");
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneNotIn(List<String> values) {
            addCriterion("coupon.ReceiverPhone not in", values, "receiverPhone");
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneBetween(String value1, String value2) {
            addCriterion("coupon.ReceiverPhone between", value1, value2, "receiverPhone");
            return (Criteria) this;
        }

        public Criteria andReceiverPhoneNotBetween(String value1, String value2) {
            addCriterion("coupon.ReceiverPhone not between", value1, value2, "receiverPhone");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeIsNull() {
            addCriterion("coupon.CurrencyType is null");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeIsNotNull() {
            addCriterion("coupon.CurrencyType is not null");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeEqualTo(String value) {
            addCriterion("coupon.CurrencyType =", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CurrencyType = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotEqualTo(String value) {
            addCriterion("coupon.CurrencyType <>", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CurrencyType <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThan(String value) {
            addCriterion("coupon.CurrencyType >", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CurrencyType > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThanOrEqualTo(String value) {
            addCriterion("coupon.CurrencyType >=", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CurrencyType >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThan(String value) {
            addCriterion("coupon.CurrencyType <", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CurrencyType < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThanOrEqualTo(String value) {
            addCriterion("coupon.CurrencyType <=", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CurrencyType <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLike(String value) {
            addCriterion("coupon.CurrencyType like", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotLike(String value) {
            addCriterion("coupon.CurrencyType not like", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeIn(List<String> values) {
            addCriterion("coupon.CurrencyType in", values, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotIn(List<String> values) {
            addCriterion("coupon.CurrencyType not in", values, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeBetween(String value1, String value2) {
            addCriterion("coupon.CurrencyType between", value1, value2, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotBetween(String value1, String value2) {
            addCriterion("coupon.CurrencyType not between", value1, value2, "currencyType");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("coupon.`Status` is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("coupon.`Status` is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("coupon.`Status` =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.`Status` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("coupon.`Status` <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.`Status` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("coupon.`Status` >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.`Status` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("coupon.`Status` >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.`Status` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("coupon.`Status` <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.`Status` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("coupon.`Status` <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.`Status` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("coupon.`Status` in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("coupon.`Status` not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("coupon.`Status` between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("coupon.`Status` not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("coupon.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("coupon.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("coupon.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("coupon.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("coupon.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("coupon.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("coupon.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("coupon.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("coupon.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("coupon.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("coupon.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("coupon.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("coupon.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("coupon.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("coupon.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("coupon.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("coupon.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("coupon.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("coupon.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("coupon.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("coupon.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("coupon.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("coupon.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("coupon.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("coupon.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("coupon.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("coupon.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("coupon.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("coupon.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("coupon.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("coupon.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("coupon.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("coupon.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("coupon.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("coupon.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("coupon.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("coupon.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("coupon.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("coupon.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("coupon.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("coupon.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("coupon.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("coupon.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("coupon.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("coupon.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("coupon.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("coupon.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("coupon.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("coupon.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("coupon.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("coupon.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("coupon.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("coupon.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("coupon.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("coupon.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("coupon.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("coupon.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("coupon.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("coupon.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("coupon.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(Coupon.Column column) {
            addCriterion(new StringBuilder("coupon.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("coupon.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("coupon.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("coupon.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("coupon.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private CouponExample example;

        protected Criteria(CouponExample example) {
            super();
            this.example = example;
        }

        public CouponExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(Coupon.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(Coupon.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.chinadutyfree.retailer.entity.CouponExample example);
    }
}